home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / r / func_str.result < prev    next >
Encoding:
Text File  |  2003-01-21  |  4.9 KB  |  113 lines  |  [TEXT/ttxt]
  1. hello    'hello'    ""hello""    'h'e'l'l'o'    hel"lo    hel'lo
  2. hello    'hello'    ""hello""    'h'e'l'l'o'    hel"lo    hel'lo
  3. hello
  4. hellomonty
  5. length('\n\t\r\b\0\_\%\\')
  6. 10
  7. concat('monty',' was here ','again')    length('hello')    char(ascii('h'))
  8. monty was here again    5    h
  9. locate('he','hello')    locate('he','hello',2)    locate('lo','hello',2)
  10. 1    0    4
  11. instr('hello','he')
  12. 1
  13. position('ll' in 'hello')    position('a' in 'hello')
  14. 3    0
  15. left('hello',2)    right('hello',2)    substring('hello',2,2)    mid('hello',1,5)
  16. he    lo    el    hello
  17. concat('',left(right(concat('what ',concat('is ','happening')),9),4),'',substring('monty',5,1))
  18. happy
  19. substring_index('www.tcx.se','.',-2)    substring_index('www.tcx.se','.',1)
  20. tcx.se    www
  21. substring_index('www.tcx.se','tcx',1)    substring_index('www.tcx.se','tcx',-1)
  22. www.    .se
  23. substring_index('.tcx.se','.',-2)    substring_index('.tcx.se','.tcx',-1)
  24. tcx.se    .se
  25. concat(':',ltrim('  left  '),':',rtrim('  right  '),':')
  26. :left  :  right:
  27. concat(':',trim(LEADING FROM ' left'),':',trim(TRAILING FROM ' right '),':')
  28. :left: right:
  29. concat(':',trim(' m '),':',trim(BOTH FROM ' y '),':',trim('*' FROM '*s*'),':')
  30. :m:y:s:
  31. concat(':',trim(BOTH 'ab' FROM 'ababmyabab'),':',trim(BOTH '*' FROM '***sql'),':')
  32. :my:sql:
  33. concat(':',trim(LEADING '.*' FROM '.*my'),':',trim(TRAILING '.*' FROM 'sql.*.*'),':')
  34. :my:sql:
  35. TRIM("foo" FROM "foo")    TRIM("foo" FROM "foook")    TRIM("foo" FROM "okfoo")
  36.     ok    ok
  37. concat_ws(', ','monty','was here','again')
  38. monty, was here, again
  39. concat_ws(NULL,'a')    concat_ws(',',NULL,'')
  40. NULL    
  41. concat_ws(',','',NULL,'a')
  42. a
  43. CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"')
  44. "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb";"cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc";"dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd"
  45. insert('txs',2,1,'hi')    insert('is ',4,0,'a')    insert('txxxxt',2,4,'es')
  46. this    is a    test
  47. replace('aaaa','a','b')    replace('aaaa','aa','b')    replace('aaaa','a','bb')    replace('aaaa','','b')    replace('bbbb','a','c')
  48. bbbb    bb    bbbbbbbb    aaaa    bbbb
  49. replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL')
  50. this is a REAL test
  51. soundex('')    soundex('he')    soundex('hello all folks')
  52.     H000    H4142
  53. password('test')    length(encrypt('test'))    encrypt('test','aa')
  54. 378b243e220ca493    13    aaqPiZY5xR5l.
  55. md5('hello')
  56. 5d41402abc4b2a76b9719d911017c592
  57. repeat('monty',5)    concat('*',space(5),'*')
  58. montymontymontymontymonty    *     *
  59. reverse('abc')    reverse('abcd')
  60. cba    dcba
  61. rpad('a',4,'1')    rpad('a',4,'12')    rpad('abcd',3,'12')
  62. a111    a121    abc
  63. lpad('a',4,'1')    lpad('a',4,'12')    lpad('abcd',3,'12')
  64. 111a    121a    abc
  65. rpad(741653838,17,'0')    lpad(741653838,17,'0')
  66. 74165383800000000    00000000741653838
  67. rpad('abcd',7,'ab')    lpad('abcd',7,'ab')
  68. abcdaba    abaabcd
  69. rpad('abcd',1,'ab')    lpad('abcd',1,'ab')
  70. a    a
  71. LEAST(NULL,'HARRY','HARRIOT',NULL,'HAROLD')    GREATEST(NULL,'HARRY','HARRIOT',NULL,'HAROLD')
  72. HAROLD    HARRY
  73. least(1,2,3) | greatest(16,32,8)    least(5,4)*1    greatest(-1.0,1.0)*1    least(3,2,1)*1.0    greatest(1,1.1,1.0)    least("10",9)    greatest("A","B","0")
  74. 33    4    1.0    1.0    1.1    9    B
  75. decode(encode(repeat("a",100000),"monty"),"monty")=repeat("a",100000)
  76. 1
  77. decode(encode("abcdef","monty"),"monty")="abcdef"
  78. 1
  79. reverse("")
  80.  
  81. insert("aa",100,1,"b")    insert("aa",1,3,"b")    left("aa",-1)    substring("a",1,2)
  82. aa    b        a
  83. elt(2,1)    field(NULL,"a","b","c")    reverse("")
  84. NULL    0    
  85. locate("a","b",2)    locate("","a",1)
  86. 0    1
  87. ltrim("a")    rtrim("a")    trim(BOTH "" from "a")    trim(BOTH " " from "a")
  88. a    a    a    a
  89. concat("1","2")|0    concat("1",".5")+0.0
  90. 12    1.5
  91. substring_index("www.tcx.se","",3)
  92.  
  93. length(repeat("a",100000000))    length(repeat("a",1000*64))
  94. NULL    64000
  95. position("0" in "baaa" in (1))    position("0" in "1" in (1,2,3))    position("sql" in ("mysql"))
  96. 1    0    3
  97. position(("1" in (1,2,3)) in "01")
  98. 2
  99. length(repeat("a",65500))    length(concat(repeat("a",32000),repeat("a",32000)))    length(replace("aaaaa","a",concat(repeat("a",10000))))    length(insert(repeat("a",40000),1,30000,repeat("b",50000)))
  100. 65500    64000    50000    60000
  101. length(repeat("a",1000000))    length(concat(repeat("a",32000),repeat("a",32000),repeat("a",32000)))    length(replace("aaaaa","a",concat(repeat("a",32000))))    length(insert(repeat("a",48000),1,1000,repeat("a",48000)))
  102. 1000000    96000    160000    95000
  103. domain
  104. hello.de
  105. domain
  106. test.de
  107. CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified,bugstatus,submitter), '"')
  108. "Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4"
  109. CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter), '"')
  110. "Link";"1";"1";"1";"0";"4"
  111. CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified,bugstatus,submitter)
  112. Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4
  113.